V3.1.0

Member Risk Profile

The Health Chain Member Risk Profile data mart is a specialized, centralized repository of data designed to drive risk management insights, including but not limited to; diagnoses codes, risk assessment, risk score assigned to the member, risk assessment date, practitioner, and more!

Table	Column	Datatype	Description
hc_patient	patient_id	varchar	Unique identifier for each patient
hc_humanname	first_name	varchar	Patient's first name
hc_humanname	last_name	varchar	Patient's last name
hc_patient	dob	date	Patient's date of birth
hc_patient	gender	varchar	Patient's gender
hc_address	address	varchar	Patient's address
hc_address	city	varchar	City of patient's address
hc_address	state	varchar	State of patient's address
hc_address	postal_code	varchar	Postal code of patient's address
hc_risk_assesment	assessment_id	varchar	Unique identifier for each risk assessment
hc_reference	condition_id	varchar	Unique identifier for the condition assessed
hc_risk_assesment_prediction	probability_decimal	decimal	Risk score assigned to the patient
hc_risk_assesment	occurrence_date_time	date	Date when the risk assessment was performed
hc_condition	code	varchar	Code representing the condition
hc_condition	description	varchar	Description of the condition
hc_condition	onset_date_time	date	Date when the condition was first noted
hc_procedure	procedure_id	varchar	Unique identifier for each procedure
hc_codeableconcept	codeableconcept_code	varchar	Code representing the procedure
hc_codeableconcept	codeableconcept_text	varchar	Description of the procedure
hc_procedure	performed_date_time	date	Date when the procedure was performed
hc_procedure	status	varchar	Reason Reference
hc_reference	Practitioner	varchar	Performer
hc_codeableconcept	result of the procedure	varchar	Justification that the procedure is performed
hc_practitioner	practitioner_id	varchar	Practitioner who gave service to the Patient
hc_humanname	Name	varchar	Practitioner's name
hc_contactpoint	Telecom	varchar	Practitioner's contact number
hc_address	Address	varchar	Practitioner's full address including Plot No, city and state
hc_practitioner	Gender	varchar	Practitioner's Gender
hc_practitioner	DOB	date	Practitioner's DOB
hc_observation	observation_id	varchar	Unique identifier for each observation
hc_codeableconcept	code	varchar	Code representing the observation
hc_codeableconcept	value	decimal	Value of the observation
hc_codeableconcept	effective_date_time	date	Date when the observation was made
hc_reference	Performer	varchar	Who is responsible for the observation
hc_reference	encounter	varchar	Healthcare event during which this observation is made
hc_codeableconcept	Type of Observation	varchar	Classification of type of observation
hc_observation	status	varchar	Observation status